<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE html 
     PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
     "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html>
<head>
  <title>normalize_first_form (normalizing_first.rb)</title>
  <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
  <link rel="stylesheet" href="../.././rdoc-style.css" type="text/css" media="screen" />
</head>
<body class="standalone-code">
  <pre><span class="ruby-comment cmt"># File normalizing_first.rb, line 1</span>
 <span class="ruby-keyword kw">def</span> <span class="ruby-identifier">normalize_first_form</span>       
        <span class="ruby-identifier">root_table_array</span> = <span class="ruby-identifier">get_root_tables</span>(<span class="ruby-value str">&quot;first_normalize_config.csv&quot;</span>)
        <span class="ruby-identifier">connection_options</span> = <span class="ruby-identifier">extract_connection_options</span>(<span class="ruby-value str">&quot;first_normalize_config.csv&quot;</span>)
        <span class="ruby-identifier">new_connection</span> = <span class="ruby-identifier">create_new_connection</span>(<span class="ruby-identifier">connection_options</span>)
        <span class="ruby-keyword kw">for</span> <span class="ruby-identifier">root_table</span> <span class="ruby-keyword kw">in</span> <span class="ruby-identifier">root_table_array</span>
                <span class="ruby-identifier">create_structure_csv_file</span>(<span class="ruby-identifier">root_table</span>,<span class="ruby-identifier">new_connection</span>)
                <span class="ruby-constant">FasterCSV</span>.<span class="ruby-identifier">foreach</span>(<span class="ruby-value str">&quot;first_normalize_config.csv&quot;</span>) <span class="ruby-keyword kw">do</span> <span class="ruby-operator">|</span><span class="ruby-identifier">row</span><span class="ruby-operator">|</span>
                        <span class="ruby-keyword kw">if</span> <span class="ruby-identifier">row</span>.<span class="ruby-identifier">first</span> <span class="ruby-operator">==</span> <span class="ruby-value str">&quot;child tables&quot;</span> 
                                <span class="ruby-keyword kw">for</span> <span class="ruby-identifier">i</span> <span class="ruby-keyword kw">in</span> <span class="ruby-value">3</span><span class="ruby-operator">..</span><span class="ruby-identifier">row</span>.<span class="ruby-identifier">length</span>
                                        <span class="ruby-keyword kw">if</span> <span class="ruby-identifier">row</span>[<span class="ruby-value">1</span>] <span class="ruby-operator">==</span> <span class="ruby-identifier">root_table</span>
                                                <span class="ruby-keyword kw">if</span> <span class="ruby-identifier">row</span>[<span class="ruby-identifier">i</span>] <span class="ruby-operator">!=</span> <span class="ruby-keyword kw">nil</span>
                                                        <span class="ruby-identifier">column_struc</span> = <span class="ruby-identifier">get_the_col_specs</span>(<span class="ruby-identifier">row</span>[<span class="ruby-identifier">i</span>],<span class="ruby-identifier">root_table</span>)
                                                        <span class="ruby-keyword kw">if</span> <span class="ruby-identifier">i</span> <span class="ruby-operator">==</span> <span class="ruby-value">3</span>
                                                                <span class="ruby-identifier">puts</span> <span class="ruby-identifier">row</span>[<span class="ruby-identifier">i</span>]
                                                                <span class="ruby-identifier">puts</span> <span class="ruby-identifier">column_struc</span>
                                                                <span class="ruby-identifier">puts</span> 
                                                                <span class="ruby-identifier">new_connection</span>.<span class="ruby-identifier">query</span>(<span class="ruby-node">&quot;CREATE TABLE #{row[2]}(#{row[i]} #{column_struc})&quot;</span>)
                                                        <span class="ruby-keyword kw">else</span>
                                                                <span class="ruby-identifier">new_connection</span>.<span class="ruby-identifier">query</span>(<span class="ruby-node">&quot;ALTER TABLE #{row[2]} ADD #{row[i]} #{column_struc}&quot;</span>)
                                                        <span class="ruby-keyword kw">end</span>      
                                                <span class="ruby-keyword kw">end</span>       
                                        <span class="ruby-keyword kw">end</span>        
                                <span class="ruby-keyword kw">end</span>
                        <span class="ruby-keyword kw">end</span>
                <span class="ruby-keyword kw">end</span>   
        <span class="ruby-keyword kw">end</span>
 <span class="ruby-keyword kw">end</span></pre>
</body>
</html>